<?php

//Connect to MySQL

  $connection = mysql_connect( "127.0.0.1", "root", "abc123" );
  
  if ( !$connection )
  {
    die("Could not connect: " . mysql_error() );    
  }

  mysql_select_db( "sasystemTables", $connection );

//Close the connection

  $query = "CREATE TABLE Assignments ( pairID int AUTO_INCREMENT PRIMARY KEY, userID varchar(45), teacherID varchar(45) );";
  
  $result = mysql_query( $query, $connection );

  mysql_close( $connection );

?>

